alter table Candidate add ChangeDate DateTime;

update	Candidate
set		ChangeDate = GetDate();